﻿// Copyright (c) Appeon. All rights reserved.
// Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. 
// You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0.

using System.Data;

namespace SnapObjects.Data.MySql
{
    internal class MySqlProcedureColumnSchemaProvider : ProcedureColumnSchemaProvider
    {
        public MySqlProcedureColumnSchemaProvider(DataContext dataContext) : base(dataContext)
        {
        }

        protected override string ColumnDataTypeName(DataRow row, IDataReader reader)
        {
            var ordinal = this.ColumnOrdinal(row, reader);

            if (reader != null && ordinal > -1 && ordinal < reader.FieldCount)
            {
                return reader.GetDataTypeName(ordinal);
            }

            return null;
        }

        protected override int ColumnOrdinal(DataRow row, IDataReader reader)
        {
            var firstRowOrdinal = base.ColumnOrdinal(row.Table.Rows[0], reader);

            var currentRowOrdinal = base.ColumnOrdinal(row, reader);

            return firstRowOrdinal > 0 ? currentRowOrdinal - 1 : currentRowOrdinal;
        }
    }
}
